Functions/Procedures

Stored routines (procedures and functions) are supported in MySQL 5.0. A stored routine is a set of SQL statements that can be stored in the server. Once this has been done, clients do not need to keep reissuing the individual statements but can refer to the stored routines instead.

Just simply click to open an object pane for Function. By using the object pane toolbar below, you can create new, edit and delete the selected function.

Create Function/Procedure

To create a new function/procedure

To create a new function/procedure with the same properties as one of the existing function/procedure has (using drag and drop method)

Apply to: current database {same connection}
Apply to: different database {same connection}
  different database {different connection} (Data Transfer tool will be activated)
  • Select the function/procedure(s) for copying in the object pane.
  • Drag and drop the chosen function/procedure(s) to the target database.
  • Select one of the following options:

    • Copy
    • Cancel

To create a new function/procedure with the same properties as one of the existing function/procedure has

To create a new function/procedure with modification as one of the existing function/procedure

Edit Function/Procedure

To edit the existing function/procedure (manage its definition etc)

To change the name of the function/procedure

Run Function/Procedure

To run a function/procedure in the navigation pane/object pane

To run a function/procedure in the Function/Procedure Designer

Delete Function/Procedure

To delete a function/procedure

Achieve Function/Procedure Information

To achieve a function/procedure information